<%@ page language="java" contentType="text/html; charset=utf-8"
	pageEncoding="utf-8"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<%
	   String stuId = (String) session.getAttribute("stuId");
	   String classId = request.getParameter("classId");
	   String stuName = new String(request.getParameter("stuName").getBytes("ISO-8859-1"),"UTF-8");
	   String stuSex = new String(request.getParameter("stuSex").getBytes("ISO-8859-1"),"UTF-8");
	   String stuPwd = request.getParameter("stuPwd");
       try{
	       	   Class.forName("com.mysql.jdbc.Driver").newInstance();
	       	   Connection con = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/classfee", "root", "1234");
	       	   Statement stmt = con.createStatement();
    	       stmt.executeUpdate("update tb_student set classId='"+classId+"',stuName='" +stuName+"',stuSex='"+stuSex+"',stuPwd='"+stuPwd+"' where stuId='"+stuId+"'");
    	       out.println("<script>alert('修改成功!');window.location='studentInfo.jsp'</script>");
    	       stmt.close();
    	       con.close();
         }
      catch(Exception ex)
      { 
    	   out.println("<script>alert('修改失败!')window.location='studentupdate1.jsp'</script>");
    	   out.println(ex.getMessage());
      }
	       
%>
